﻿using ShipborneDataTerminal.Base;
using System;
using System.Collections.Generic;
using System.IO.Ports;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Timers;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using MySql.Data.MySqlClient;

namespace ShipborneDataTerminal.view
{
    /// <summary>
    /// Portset.xaml 的交互逻辑
    /// </summary>
    public partial class Portset : UserControl
    {
        public Portset()
        {
            InitializeComponent();

        }


        System.Timers.Timer timer;

        public byte[] recive;
        public List<byte> Recive = new List<byte>();

        public SerialPort serialPort = new SerialPort();

        List<byte> SendCommand = new List<byte>();
        sqlConnection sqlcon = new sqlConnection();

        private int _recivecount;// 寄存器长度
        public int _Recivecount
        {
            get { return _recivecount; }
            set { _recivecount = value; }
        }

        private void parityComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {

        }
        /// <summary>
        /// 获取串口
        /// </summary>
        public void FindPort()
        {


            int i = 0;
            this.portsComboBox.Items.Clear(); // 清除串口
            string[] gCOM = System.IO.Ports.SerialPort.GetPortNames(); // 获取设备的所有可用串口
            int j = gCOM.Length; // 得到所有可用串口数目
            for (i = 0; i < j; i++)
            {
                this.portsComboBox.Items.Add(gCOM[i]); // 依次添加到下拉框中
            }
        }

        private void portsComboBox_DropDownOpened(object sender, EventArgs e)
        {
            FindPort();
        }

        private void serialPortOpen_click(object sender, RoutedEventArgs e)
        {
            SeialPort_Open();
        }

        public void SeialPort_Open()
        {
            ConfigurePort();
            try
            {
                serialPort.Open();
                MessageBox.Show("成功打开");
            }
            catch (Exception ex)
            {
            }

        }
        /// <summary>
        /// 串口参数设置
        /// </summary>
        private void ConfigurePort()
        {
            serialPort.PortName = GetSelectedPortName();
            serialPort.BaudRate = GetSelectedBaudRate();
            serialPort.Parity = GetSelectedParity();
            serialPort.DataBits = GetSelectedDataBits();
            serialPort.StopBits = GetSelectedStopBits();
            serialPort.Encoding = GetSelectedEncoding();
        }

        private string GetSelectedPortName()
        {
            return portsComboBox.Text;
        }

        private int GetSelectedBaudRate()
        {
            int baudRate = 9600;
            //string conv = baudRateComboBox.Text;
            int.TryParse(baudRateComboBox.Text, out baudRate);
            return baudRate;
        }
        private Parity GetSelectedParity()
        {
            string select = parityComboBox.Text;

            Parity p = Parity.None;
            if (select.Contains("Odd"))
            {
                p = Parity.Odd;
            }
            else if (select.Contains("Even"))
            {
                p = Parity.Even;
            }
            else if (select.Contains("Space"))
            {
                p = Parity.Space;
            }
            else if (select.Contains("Mark"))
            {
                p = Parity.Mark;
            }

            return p;
        }
        private int GetSelectedDataBits()
        {
            int dataBits = 8;
            int.TryParse(dataBitsComboBox.Text, out dataBits);

            return dataBits;
        }
        private StopBits GetSelectedStopBits()
        {
            StopBits stopBits = StopBits.None;
            string select = stopBitsComboBox.Text.Trim();

            if (select.Equals("1"))
            {
                stopBits = StopBits.One;
            }
            else if (select.Equals("1.5"))
            {
                stopBits = StopBits.OnePointFive;
            }
            else if (select.Equals("2"))
            {
                stopBits = StopBits.Two;
            }

            return stopBits;
        }
        private Encoding GetSelectedEncoding()
        {
            string select = encodingComboBox.Text;
            Encoding enc = Encoding.Default;

            if (select.Contains("UTF-8"))
            {
                enc = Encoding.UTF8;
            }
            else if (select.Contains("ASCII"))
            {
                enc = Encoding.ASCII;
            }
            else if (select.Contains("Unicode"))
            {
                enc = Encoding.Unicode;
            }

            return enc;
        }

        private void serialPortClose_click(object sender, RoutedEventArgs e)
        {
            serialPort.Close();
            MessageBox.Show("成功关闭");
        }


        /// <summary>
        /// 获取功能码
        /// </summary>
        /// <returns></returns>
        private int GetSelectedFun()
        {
            int Funcode = 0x03;
            int.TryParse(FunComboBox.Text, out Funcode);

            return Funcode;
        }

        /// <summary>
        /// 字符串转16进制字节数组
        /// </summary>
        /// <param name="hexString"></param>
        /// <returns></returns>

        private static byte[] strToToHexByte(string hexString)
        {
            hexString = hexString.Replace(" ", "");
            if ((hexString.Length % 2) != 0)
                hexString = hexString.Insert(hexString.Length - 1, 0.ToString());
            byte[] returnBytes = new byte[hexString.Length / 2];
            for (int i = 0; i < returnBytes.Length; i++)
                returnBytes[i] = Convert.ToByte(hexString.Substring(i * 2, 2), 16);
            return returnBytes;

        }

        /// <summary>
        /// 获取通信协议参数
        /// </summary>
        public void ConfigureModbus()

        {

            byte[] SlaveID = strToToHexByte(SlaveIDTextBox.Text);
            byte[] Fun_code = new byte[1];
            int selectvalue = FunComboBox.SelectedIndex;
            switch (selectvalue)
            {
                case 0:
                    Fun_code[0] = 0x01;
                    break;
                case 1:
                    Fun_code[0] = 0x02;
                    break;
                case 2:
                    Fun_code[0] = 0x03;

                    break;
                case 3:
                    Fun_code[0] = 0x04;
                    break;

            }



            // byte[] Fun_code = Encoding.Default.GetBytes(FunComboBox.Text);
            int StartAdd = Convert.ToInt32(StartAddress.Text);


            int Qty = Convert.ToInt32(RegisterQty.Text);

            ushort len = (ushort)Qty;

            string Address_mode = AddressMode.Text;
            string sample = Sample.Text;
            string value = FunComboBox.Text;

            if (SendCommand.Count != 0)
            {
                SendCommand.Clear();
            }

            //拼接报文
            SendCommand.Add(SlaveID[0]);
            SendCommand.Add(Fun_code[0]);
            //SendCommand.Add(0x03);


            SendCommand.Add((byte)(StartAdd / 256));
            SendCommand.Add((byte)(StartAdd % 256));

            //SendCommand.Add((byte)(Qty / 256));
            //SendCommand.Add((byte)(Qty % 256));

            SendCommand.Add(BitConverter.GetBytes(len)[1]);
            SendCommand.Add(BitConverter.GetBytes(len)[0]);

            byte[] crc = Crc16(SendCommand.ToArray(), 6);

            SendCommand.AddRange(crc);


        }

        private byte[] Crc16(byte[] pucFrame, int ueLen)
        {
            int i = 0;
            byte[] res = new byte[2] { 0xff, 0xff };
            ushort iIndex;
            while (ueLen-- > 0)
            {
                iIndex = (ushort)(res[0] ^ pucFrame[i++]);
                res[0] = (byte)(res[1] ^ aucCRCHi[iIndex]);
                res[1] = aucCRCLo[iIndex];

            }
            return res;


        }

        // 逆序CRC表 
        #region
        private byte[] aucCRCHi = new byte[]  {
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x00, 0xC1, 0x81, 0x40,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40, 0x01, 0xC0, 0x80, 0x41, 0x01, 0xC0, 0x80, 0x41,
            0x00, 0xC1, 0x81, 0x40
        };


        private byte[] aucCRCLo = new byte[] {
            0x00, 0xC0, 0xC1, 0x01, 0xC3, 0x03, 0x02, 0xC2, 0xC6, 0x06, 0x07, 0xC7,
            0x05, 0xC5, 0xC4, 0x04, 0xCC, 0x0C, 0x0D, 0xCD, 0x0F, 0xCF, 0xCE, 0x0E,
            0x0A, 0xCA, 0xCB, 0x0B, 0xC9, 0x09, 0x08, 0xC8, 0xD8, 0x18, 0x19, 0xD9,
            0x1B, 0xDB, 0xDA, 0x1A, 0x1E, 0xDE, 0xDF, 0x1F, 0xDD, 0x1D, 0x1C, 0xDC,
            0x14, 0xD4, 0xD5, 0x15, 0xD7, 0x17, 0x16, 0xD6, 0xD2, 0x12, 0x13, 0xD3,
            0x11, 0xD1, 0xD0, 0x10, 0xF0, 0x30, 0x31, 0xF1, 0x33, 0xF3, 0xF2, 0x32,
            0x36, 0xF6, 0xF7, 0x37, 0xF5, 0x35, 0x34, 0xF4, 0x3C, 0xFC, 0xFD, 0x3D,
            0xFF, 0x3F, 0x3E, 0xFE, 0xFA, 0x3A, 0x3B, 0xFB, 0x39, 0xF9, 0xF8, 0x38,
            0x28, 0xE8, 0xE9, 0x29, 0xEB, 0x2B, 0x2A, 0xEA, 0xEE, 0x2E, 0x2F, 0xEF,
            0x2D, 0xED, 0xEC, 0x2C, 0xE4, 0x24, 0x25, 0xE5, 0x27, 0xE7, 0xE6, 0x26,
            0x22, 0xE2, 0xE3, 0x23, 0xE1, 0x21, 0x20, 0xE0, 0xA0, 0x60, 0x61, 0xA1,
            0x63, 0xA3, 0xA2, 0x62, 0x66, 0xA6, 0xA7, 0x67, 0xA5, 0x65, 0x64, 0xA4,
            0x6C, 0xAC, 0xAD, 0x6D, 0xAF, 0x6F, 0x6E, 0xAE, 0xAA, 0x6A, 0x6B, 0xAB,
            0x69, 0xA9, 0xA8, 0x68, 0x78, 0xB8, 0xB9, 0x79, 0xBB, 0x7B, 0x7A, 0xBA,
            0xBE, 0x7E, 0x7F, 0xBF, 0x7D, 0xBD, 0xBC, 0x7C, 0xB4, 0x74, 0x75, 0xB5,
            0x77, 0xB7, 0xB6, 0x76, 0x72, 0xB2, 0xB3, 0x73, 0xB1, 0x71, 0x70, 0xB0,
            0x50, 0x90, 0x91, 0x51, 0x93, 0x53, 0x52, 0x92, 0x96, 0x56, 0x57, 0x97,
            0x55, 0x95, 0x94, 0x54, 0x9C, 0x5C, 0x5D, 0x9D, 0x5F, 0x9F, 0x9E, 0x5E,
            0x5A, 0x9A, 0x9B, 0x5B, 0x99, 0x59, 0x58, 0x98, 0x88, 0x48, 0x49, 0x89,
            0x4B, 0x8B, 0x8A, 0x4A, 0x4E, 0x8E, 0x8F, 0x4F, 0x8D, 0x4D, 0x4C, 0x8C,
            0x44, 0x84, 0x85, 0x45, 0x87, 0x47, 0x46, 0x86, 0x82, 0x42, 0x43, 0x83,
            0x41, 0x81, 0x80, 0x40
        };
        #endregion

        /// <summary>
        /// 读报文 并解析
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void readClick(object sender, RoutedEventArgs e)
        {
            int select_value = FunComboBox.SelectedIndex;

            switch (select_value)
            {
                case 0:
                    ;
                    break;
                case 1:
                    ;
                    break;
                case 2:

                    Text();


                    break;


                case 3:
                    ;
                    break;

            }


        }


        public void Text()
        {

            if (Sample.Text != "")
            {
                int interval = Convert.ToInt32(Sample.Text);

                timer = new System.Timers.Timer();
                timer.Interval = interval; //时间间隔 1000ms
                timer.Elapsed += new System.Timers.ElapsedEventHandler(Text_0x30);
                timer.Enabled = true;
            }
            else
            {
                MessageBox.Show("请输入采用周期！");

            }



        }


        /// <summary>
        /// 解析读取寄存器状态 03表示功能码
        /// </summary>
        public void Text_0x30(object sender, System.Timers.ElapsedEventArgs e)
        {



            this.Dispatcher.Invoke(System.Windows.Threading.DispatcherPriority.Normal, (ThreadStart)delegate ()

            {

                ConfigureModbus();

                serialPort.WriteTimeout = 500;
                serialPort.ReadTimeout = 500;
                serialPort.Write(SendCommand.ToArray(), 0, SendCommand.Count);

                //报文接收和解析
                byte[] respBytes = new byte[serialPort.BytesToRead];
                serialPort.Read(respBytes, 0, respBytes.Length);

                ////检查一个校验位
                //List<byte> respList = new List<byte>(respBytes);
                //respList.RemoveRange(0,3);
                //respList.RemoveRange(respList.Count-2,2);

                //数据解析
                ushort count = (ushort)Convert.ToInt32(RegisterQty.Text);
                if (respBytes.Length == 5 + 2 * count)
                {
                    byte[] result = new byte[count * 2];
                    byte[] recive = new byte[count];
                    Array.Copy(respBytes, 3, result, 0, count * 2);

                    for (int j = 0; j < recive.Length; j++)
                    {
                        recive[j] = result[j * 2 + 1];


                    }


                    for (int i = 0; i < recive.Length; i++)
                    {

                        this.readbuff.Text = this.readbuff.Text + recive[i] + " ";
                        if (i == recive.Length - 1)
                        {
                            this.readbuff.Text = this.readbuff.Text + "\n";
                        }

                    }
                    Recive.AddRange(recive);
                    _recivecount = recive.Length;


                    Array.Clear(result, 0, result.Length);
                    Array.Clear(recive, 0, recive.Length);
                }
            });

        }
        /// <summary>
        /// 测试连接mysql
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void conSql(object sender, RoutedEventArgs e)
        {

            sqlcon.OpenConnection();
            MessageBox.Show("数据库连接成功");


            timer = new System.Timers.Timer();
            timer.Interval = 4000; //时间间隔 1000ms
            timer.Elapsed += new System.Timers.ElapsedEventHandler(insert);
            timer.Enabled = true;



        }
        public void insert(object sender, System.Timers.ElapsedEventArgs e)
        {

            string inserttable = "insert into person(data1,data2,data3,data4,data5,data6,data7,data8,data9,data10) values(@data1,@data2,@data3,@data4,@data5,@data6,@data7,@data8,@data9,@data10)";
            for(int h=0;h< _recivecount;h++)
            {
                MySqlParameter p = new MySqlParameter("@data"+ Convert.ToString(h), MySqlDbType.Int32);
                p.Value = Recive[h];
                
                using (MySqlCommand cmd = new MySqlCommand(inserttable, sqlcon.connection))
                {
                    cmd.Parameters.Add(p);
                }


            }











        }
    }
}



